How to change the thousands separator for numeric values

You can choose whether to use a character to separate thousands values on your reports. Most commonly this will be a comma, e.g. 10,000. This explains how to add or remove a thousands separator.

How to locate the report or document

Open: Tools > Run Sage Report Designer

  1. Go to File Explorer section.

    The default reports are all stored under the Defaults folder by type of report and module such as nominal, purchases etc:

    If you've previously amended the report or document, it will be saved in the Custom or Company folder.

How to change the separator

  1. Select the value you want to change on the document.

    To multi- select and change several values at once, you can use Ctrl+ click, or drag the mouse over a section of the report.

  2. Select the Numeric tab.
  3. Select Use custom thousand separator and click Edit.
  4. Add or remove the character to use as the separator. You'll see how the number will display in the Preview section.
  5. Click OK.

Tip: Preview the document to check that it's displaying correctly (View > Preview).

Where to save the amended report or document

When you save a customised report or document, make sure to save it in a new folder. This is to make sure that the original isn't lost.

If you have more than one companyschool on your site, you can choose whether the amended report should be used for all companiesschools, or just for a specific one.

When you generate a report or document Sage 200 first looks for the version in the Company folder, then the Custom folder, and if it does not find one it uses the 'out of the box' version. For each report, it will check in a specific folder for a specific filename.